DROP TABLE Track_has_Artist;
DROP TABLE Track_has_Genre;
DROP TABLE AudioTrack;
DROP TABLE SoundRecordingStudio;
DROP TABLE Artist;
DROP TABLE ID3v1Tags;
DROP TABLE Genre;
DROP SEQUENCE SoundRecordingStudio_ID_SEQ;
DROP SEQUENCE Artist_ID_SEQ;
DROP SEQUENCE Genre_ID_SEQ;
DROP SEQUENCE Track_ID_SEQ;
DROP SEQUENCE ID3v1Tag_ID_SEQ;

CREATE TABLE SoundRecordingStudio (
  ID INT NOT NULL PRIMARY KEY,
  Name VARCHAR(1024) NOT NULL
);

CREATE SEQUENCE SoundRecordingStudio_ID_SEQ
START WITH 1 INCREMENT BY 1 NOCYCLE;

CREATE TABLE Artist (
  ID INT NOT NULL PRIMARY KEY,
  Name VARCHAR(1024) NOT NULL
);

CREATE SEQUENCE Artist_ID_SEQ
START WITH 1 INCREMENT BY 1 NOCYCLE;

CREATE TABLE Genre (
  ID INT NOT NULL PRIMARY KEY,
  Name VARCHAR(1024) NOT NULL
);

CREATE SEQUENCE ID3v1Tag_ID_SEQ
START WITH 1 INCREMENT BY 1 NOCYCLE;

CREATE SEQUENCE Genre_ID_SEQ
START WITH 1 INCREMENT BY 1 NOCYCLE;

CREATE TABLE ID3v1Tags (
  ID3v1GenreID INT NOT NULL PRIMARY KEY,
  Genre_ID INT,
  FOREIGN KEY (Genre_ID) REFERENCES Genre(ID) ON DELETE SET NULL
);

CREATE TABLE AudioTrack (
  ID INT NOT NULL PRIMARY KEY,
  Name VARCHAR(1024) NOT NULL,
  Length DECIMAL NOT NULL,
  Year INT NOT NULL,
  SoundRecordingStudio_ID INT,
  FOREIGN KEY (SoundRecordingStudio_ID) REFERENCES SoundRecordingStudio(ID) ON DELETE SET NULL
);

CREATE SEQUENCE Track_ID_SEQ
START WITH 1 INCREMENT BY 1 NOCYCLE;

CREATE TABLE Track_has_Artist (
  Track_ID INT NOT NULL,
  Artist_ID INT NOT NULL,
  PRIMARY KEY (Track_ID, Artist_ID),
  FOREIGN KEY (Track_ID) REFERENCES AudioTrack(ID) ON DELETE CASCADE,
  FOREIGN KEY (Artist_ID) REFERENCES Artist(ID) ON DELETE CASCADE
);

CREATE TABLE Track_has_Genre (
  Track_ID INT NOT NULL,
  Genre_ID INT NOT NULL,
  PRIMARY KEY (Track_ID, Genre_ID),
  FOREIGN KEY (Track_ID) REFERENCES AudioTrack(ID) ON DELETE CASCADE,
  FOREIGN KEY (Genre_ID) REFERENCES Genre(ID) ON DELETE CASCADE
);

insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'Red Hot Chilli Peppers');
insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'Franz Ferdinand');
insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'The Beatles');
insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'The Doors');
insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'Snoop Dogg');
insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'Kasabian');
insert into Artist(ID, Name) values(Artist_ID_SEQ.nextval, 'Kaiser Chiefs');

SET SCAN OFF;

insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Blues');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Classic Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Country');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Dance');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Disco');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Funk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Grunge');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Hip-Hop');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Jazz');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Metal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'New Age');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Oldies');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Other');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Pop');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'R&B');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Rap');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Reggae');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Techno');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Industrial');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Alternative');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Ska');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Death Metal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Pranks');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Soundtrack');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Euro-Techno');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Ambient');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Trip-Hop');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Vocal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Jazz+Funk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Fusion');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Trance');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Classical');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Instrumental');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Acid');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'House');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Game');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Sound Clip');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Gospel');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Noise');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Alternative Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Bass');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Soul');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Punk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Space');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Meditative');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Instrumental Pop');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Instrumental Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Ethnic');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Gothic');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Darkwave');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Techno-Industrial');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Electronic');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Pop-Folk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Eurodance');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Dream');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Southern Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Comedy');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Cult');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Gangsta');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Top 40');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Christian Rap');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Pop/Funk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Jungle');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Native US');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Cabaret');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'New Wave');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Psychadelic');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Rave');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Showtunes');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Trailer');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Lo-Fi');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Tribal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Acid Punk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Acid Jazz');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Polka');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Retro');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Musical');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Rock & Roll');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Hard Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Folk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Folk-Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'National Folk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Swing');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Fast Fusion');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Bebob');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Latin');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Revival');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Celtic');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Bluegrass');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Avantgarde');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Gothic Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Progressive Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Psychedelic Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Symphonic Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Slow Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Big Band');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Chorus');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Easy Listening');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Acoustic');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Humour');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Speech');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Chanson');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Opera');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Chamber Music');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Sonata');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Symphony');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Booty Bass');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Primus');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Porn Groove');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Satire');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Slow Jam');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Club');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Tango');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Samba');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Folklore');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Ballad');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Power Ballad');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Rhythmic Soul');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Freestyle');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Duet');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Punk Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Drum Solo');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Acapella');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Euro-House');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Dance Hall');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Goa');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Drum & Bass');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Club - House');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Hardcore');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Terror');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Indie');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'BritPop');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Negerpunk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Polsk Punk');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Beat');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Christian Gangsta Rap');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Heavy Metal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Black Metal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Crossover');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Contemporary Christian');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Christian Rock');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Merengue');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Salsa');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Thrash Metal');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Anime');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'JPop');
insert into Genre(ID, Name) values(Genre_ID_SEQ.nextval, 'Synthpop');

SET SCAN ON;

insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 1);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 2);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 3);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 4);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 5);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 6);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 7);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 8);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 9);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 10);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 11);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 12);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 13);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 14);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 15);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 16);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 17);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 18);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 19);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 20);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 21);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 22);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 23);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 24);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 25);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 26);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 27);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 28);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 29);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 30);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 31);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 32);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 33);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 34);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 35);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 36);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 37);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 38);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 39);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 40);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 41);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 42);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 43);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 44);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 45);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 46);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 47);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 48);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 49);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 50);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 51);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 52);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 53);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 54);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 55);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 56);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 57);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 58);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 59);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 60);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 61);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 62);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 63);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 64);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 65);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 66);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 67);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 68);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 69);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 70);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 71);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 72);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 73);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 74);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 75);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 76);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 77);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 78);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 79);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 80);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 81);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 82);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 83);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 84);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 85);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 86);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 87);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 88);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 89);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 90);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 91);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 92);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 93);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 94);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 95);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 96);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 97);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 98);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 99);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 100);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 101);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 102);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 103);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 104);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 105);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 106);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 107);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 108);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 109);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 110);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 111);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 112);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 113);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 114);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 115);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 116);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 117);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 118);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 119);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 120);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 121);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 122);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 123);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 124);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 125);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 126);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 127);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 128);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 129);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 130);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 131);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 132);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 133);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 134);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 135);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 136);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 137);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 138);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 139);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 140);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 141);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 142);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 143);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 144);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 145);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 146);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 147);
insert into ID3v1Tags(ID3v1GenreID, Genre_ID) values(ID3v1Tag_ID_SEQ.nextval, 148);

insert into SoundRecordingStudio(ID, Name) values(SoundRecordingStudio_ID_SEQ.nextval, 'Unknown');
insert into SoundRecordingStudio(ID, Name) values(SoundRecordingStudio_ID_SEQ.nextval, 'Columbia Records');
insert into SoundRecordingStudio(ID, Name) values(SoundRecordingStudio_ID_SEQ.nextval, 'RCA Records');
insert into SoundRecordingStudio(ID, Name) values(SoundRecordingStudio_ID_SEQ.nextval, 'WMG Records');
insert into SoundRecordingStudio(ID, Name) values(SoundRecordingStudio_ID_SEQ.nextval, 'Capitol');
insert into SoundRecordingStudio(ID, Name) values(SoundRecordingStudio_ID_SEQ.nextval, 'Universal Music International Div.');

insert into AudioTrack(ID, Name, Length, Year, SoundRecordingStudio_ID) values(Track_ID_SEQ.nextval,'Thick As Thieves', 186, 2009, 2);
insert into Track_has_Artist(Track_ID, Artist_ID) values (1, 6);
insert into Track_has_Genre(Track_ID, Genre_ID) values (1, 132);
insert into Track_has_Genre(Track_ID, Genre_ID) values (1, 133);
insert into Track_has_Genre(Track_ID, Genre_ID) values (1, 94);
insert into Track_has_Genre(Track_ID, Genre_ID) values (1, 21);

insert into AudioTrack(ID, Name, Length, Year, SoundRecordingStudio_ID) values(Track_ID_SEQ.nextval,'Riders on the storm', 346, 2009, 1);
insert into Track_has_Artist(Track_ID, Artist_ID) values (2, 4);
insert into Track_has_Artist(Track_ID, Artist_ID) values (2, 5);
insert into Track_has_Genre(Track_ID, Genre_ID) values (2, 94);
insert into Track_has_Genre(Track_ID, Genre_ID) values (2, 74);
insert into Track_has_Genre(Track_ID, Genre_ID) values (2, 16);
insert into Track_has_Genre(Track_ID, Genre_ID) values (2, 18);

insert into AudioTrack(ID, Name, Length, Year, SoundRecordingStudio_ID) values(Track_ID_SEQ.nextval,'Dani California', 288, 2006, 4);
insert into Track_has_Artist(Track_ID, Artist_ID) values (3, 1);
insert into Track_has_Genre(Track_ID, Genre_ID) values (3, 18);
insert into Track_has_Genre(Track_ID, Genre_ID) values (3, 94);
insert into Track_has_Genre(Track_ID, Genre_ID) values (3, 21);

insert into AudioTrack(ID, Name, Length, Year, SoundRecordingStudio_ID) values(Track_ID_SEQ.nextval,'Yesterday', 139, 1965, 5);
insert into Track_has_Artist(Track_ID, Artist_ID) values (4, 3);
insert into Track_has_Genre(Track_ID, Genre_ID) values (4, 18);
insert into Track_has_Genre(Track_ID, Genre_ID) values (4, 14);


insert into AudioTrack(ID, Name, Length, Year, SoundRecordingStudio_ID) values(Track_ID_SEQ.nextval,'Ruby', 202, 2007, 6);
insert into Track_has_Artist(Track_ID, Artist_ID) values (5, 7);
insert into Track_has_Genre(Track_ID, Genre_ID) values (5, 132);
insert into Track_has_Genre(Track_ID, Genre_ID) values (5, 133);
insert into Track_has_Genre(Track_ID, Genre_ID) values (5, 18);